Interview Questions

1. DQL stands for?

Options:

a. Dynamic Query language

b. Data Query Language?

Reveal Answer

2. Which of the following statement can be used to compare a part of a name LIKE ‘ab’

Options:

a. Select * from <table> where <column> LIKE

b. Select * from <table> where <column> LIKE

c. Select * from <table> where <column> LIKE

d. Select * from <table> where <column> LIKE

Reveal Answer

3. Which of the following statement can be used to retrieve all employees whose commission is null?

Options:

a. Select * from employee where commission =NULL

b. Select * from employee where commission = ‘ ‘

c. Select * from employee where commission IS NULL

d. Select * from employee where commission == NULL

Reveal Answer

4. ORDER BY cannot be used on which kind of column?

Options:

a. Varchar

b. Text

c. Char

d. Nchar

Reveal Answer

5. Which option is correct?

Options:

a. ORDER BY statement can be used to order multiple columns

b. ORDER BY statement cannot be used to order multiple columns

Reveal Answer

6. Which option is correct?

Options:

a. GROUP BY statement can be used to group multiple columns

b. GROUP BY statement cannot be used to group multiple columns

Reveal Answer

7. Which of the following is true regarding HAVING CLAUSE?

Options:

a. It can use only those columns that are present in the SELECT statement

b. It can use aggregate functions

c. It is used to filter the rows got after applying GROUP BY

Reveal Answer

8. Can the WHERE clause use aggregate functions?

Options:

a. Yes

b. No

Reveal Answer

9. Can the HAVING clause use the LIKE operator?

Options:

a. Yes

b. No

Reveal Answer

10. Which of the following statement can be used to retrieve the number of records in the employee table

Options:

a. select count from employee

b. select count(*) from employee

c. select distinct count(*) from employee

d. select distinct count from employee

Reveal Answer

11. Which of the following option defines the way a query can be executed efficiently?

Options:

a. query plan

b. execution plan

c. optimized plan

Reveal Answer

Interview Questions and Answer

1. DQL stands for?

2. Which of the following statement can be used to compare a part of a name LIKE ‘ab’

3. Which of the following statement can be used to retrieve all employees whose commission is null?

4. ORDER BY cannot be used on which kind of column?

5. Which option is correct?

6. Which option is correct?

7. Which of the following is true regarding HAVING CLAUSE?

8. Can the WHERE clause use aggregate functions?

9. Can the HAVING clause use the LIKE operator?

10. Which of the following statement can be used to retrieve the number of records in the employee table

11. Which of the following option defines the way a query can be executed efficiently?

Packages

Trending Certification Courses:

Microsoft Mock Exams:

Other links

About

Resources